Entity DefinitionLogical Name : CustomerOrderChargeLineItem |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| CustomerOrderID (FK)(PK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | |
| CustomerOrderLineItemSequenceNumber (FK)(PK) | A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. | IC_OR_LTM | LineNumber | smallint | |
| ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | MiscellaneousFee(TR_FE_MSC) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| MiscellaneousFee | is ordered via | CustomerOrderChargeLineItem |
| CustomerOrderChargeLineItem | is charged with | CustomerOrderChargeTaxLineItem |
| CustomerOrderChargeLineItem | has | CustomerOrderChargePriceModifier |
| CustomerOrderLineItem | can be a | CustomerOrderChargeLineItem |